package net.zjitc.mapper;

import net.zjitc.pojo.Customer;
import net.zjitc.pojo.Rule;
import net.zjitc.pojo.VipRule;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface RuleMapper {
//    @Select("select * from customer where idCard=#{idCard}")
//    public Customer selectByIdCard(@Param("idCard") String idCard);

    @Select("select * from vip_rules where vipLevel=#{level}")
    public VipRule selectVipRuleByLevel(@Param("level") String level);

    @Select("select * from rules where vipRuleId=#{vipRuleId}")
    public List<Rule> selectRuleByVipRuleId(@Param("vipRuleId") Long vipRuleId);
}
